Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	1000000
Missing cells	419628
Missing cells (%)	2.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	137.3 MiB
Average record size in memory	144.0 B

Variable types

Numeric	6
DateTime	2
Categorical	6
Text	4

Alerts

`Status` is highly imbalanced (53.2%)	Imbalance
`Title` has 139876 (14.0%) missing values	Missing
`Artist` has 139876 (14.0%) missing values	Missing
`Length` has 139876 (14.0%) missing values	Missing
`EventID` is uniformly distributed	Uniform
`EventID` has unique values	Unique
`TrackId` has 12113 (1.2%) zeros	Zeros

Reproduction

Analysis started	2024-01-25 23:27:27.081888
Analysis finished	2024-01-25 23:31:07.213946
Duration	3 minutes and 40.13 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

EventID
Real number (ℝ)

UNIFORM UNIQUE

Distinct	1000000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	499999.5

Minimum	0
Maximum	999999
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	0
5-th percentile	49999.95
Q1	249999.75
median	499999.5
Q3	749999.25
95-th percentile	949999.05
Maximum	999999
Range	999999
Interquartile range (IQR)	499999.5

Descriptive statistics

Standard deviation	288675.28
Coefficient of variation (CV)	0.57735114
Kurtosis	-1.2
Mean	499999.5
Median Absolute Deviation (MAD)	250000
Skewness	-2.5117903 × 10^-15
Sum	4.999995 × 10¹¹
Variance	8.3333417 × 10¹⁰
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
666657	1	< 0.1%
666659	1	< 0.1%
666660	1	< 0.1%
666661	1	< 0.1%
666662	1	< 0.1%
666663	1	< 0.1%
666664	1	< 0.1%
666665	1	< 0.1%
666666	1	< 0.1%
Other values (999990)	999990	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
999999	1	< 0.1%
999998	1	< 0.1%
999997	1	< 0.1%
999996	1	< 0.1%
999995	1	< 0.1%
999994	1	< 0.1%
999993	1	< 0.1%
999992	1	< 0.1%
999991	1	< 0.1%
999990	1	< 0.1%

CustID
Real number (ℝ)

Distinct	5000
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1683.5171

Minimum	0
Maximum	4999
Zeros	7086
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	0
5-th percentile	17
Q1	333
median	1277
Q3	2830
95-th percentile	4516
Maximum	4999
Range	4999
Interquartile range (IQR)	2497

Descriptive statistics

Standard deviation	1487.6956
Coefficient of variation (CV)	0.88368306
Kurtosis	-0.86694302
Mean	1683.5171
Median Absolute Deviation (MAD)	1090
Skewness	0.62799562
Sum	1.6835171 × 10⁹
Variance	2213238.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7086	0.7%
1	5075	0.5%
2	4064	0.4%
3	3438	0.3%
4	3261	0.3%
5	2960	0.3%
6	2655	0.3%
7	2498	0.2%
8	2311	0.2%
9	2276	0.2%
Other values (4990)	964376	96.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7086	0.7%
1	5075	0.5%
2	4064	0.4%
3	3438	0.3%
4	3261	0.3%
5	2960	0.3%
6	2655	0.3%
7	2498	0.2%
8	2311	0.2%
9	2276	0.2%

Value	Count	Frequency (%)
4999	105	< 0.1%
4998	98	< 0.1%
4997	83	< 0.1%
4996	97	< 0.1%
4995	103	< 0.1%
4994	100	< 0.1%
4993	101	< 0.1%
4992	115	< 0.1%
4991	95	< 0.1%
4990	93	< 0.1%

TrackId
Real number (ℝ)

ZEROS

Distinct	1700
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	576.26831

Minimum	0
Maximum	1699
Zeros	12113
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	0
5-th percentile	7
Q1	117
median	440
Q3	968
95-th percentile	1536
Maximum	1699
Range	1699
Interquartile range (IQR)	851

Descriptive statistics

Standard deviation	505.82306
Coefficient of variation (CV)	0.87775616
Kurtosis	-0.87966295
Mean	576.26831
Median Absolute Deviation (MAD)	373
Skewness	0.61914527
Sum	5.7626831 × 10⁸
Variance	255856.97
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12113	1.2%
1	8689	0.9%
2	7028	0.7%
3	6172	0.6%
4	5527	0.6%
5	5100	0.5%
6	4607	0.5%
7	4347	0.4%
8	4092	0.4%
9	3926	0.4%
Other values (1690)	938399	93.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12113	1.2%
1	8689	0.9%
2	7028	0.7%
3	6172	0.6%
4	5527	0.6%
5	5100	0.5%
6	4607	0.5%
7	4347	0.4%
8	4092	0.4%
9	3926	0.4%

Value	Count	Frequency (%)
1699	308	< 0.1%
1698	296	< 0.1%
1697	321	< 0.1%
1696	337	< 0.1%
1695	324	< 0.1%
1694	296	< 0.1%
1693	282	< 0.1%
1692	286	< 0.1%
1691	290	< 0.1%
1690	331	< 0.1%

DateTime
Date

Distinct	130988
Distinct (%)	13.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

Minimum	2014-10-01 00:00:00
Maximum	2014-12-30 23:59:00

Histogram

Histogram with fixed size bins (bins=50)

Mobile
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

1	607765
0	392235

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1000000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	607765	60.8%
0	392235	39.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	607765	60.8%
0	392235	39.2%

Most occurring characters

Value	Count	Frequency (%)
1	607765	60.8%
0	392235	39.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1000000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	607765	60.8%
0	392235	39.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	1000000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	607765	60.8%
0	392235	39.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1000000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	607765	60.8%
0	392235	39.2%

ZipCode
Real number (ℝ)

Distinct	41241
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49347.244

Minimum	501
Maximum	99403
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	501
5-th percentile	6365
Q1	26167
median	48674
Q3	72532
95-th percentile	94624
Maximum	99403
Range	98902
Interquartile range (IQR)	46365

Descriptive statistics

Standard deviation	27537.664
Coefficient of variation (CV)	0.55803855
Kurtosis	-1.1144623
Mean	49347.244
Median Absolute Deviation (MAD)	23337
Skewness	0.069503229
Sum	4.9347244 × 10¹⁰
Variance	7.5832296 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12084	48	< 0.1%
66636	45	< 0.1%
97049	45	< 0.1%
34235	45	< 0.1%
27264	44	< 0.1%
33931	44	< 0.1%
16839	44	< 0.1%
62473	44	< 0.1%
28217	44	< 0.1%
60652	44	< 0.1%
Other values (41231)	999553	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
501	24	< 0.1%
544	32	< 0.1%
1001	22	< 0.1%
1002	38	< 0.1%
1003	34	< 0.1%
1004	18	< 0.1%
1005	20	< 0.1%
1007	19	< 0.1%
1008	23	< 0.1%
1009	24	< 0.1%

Value	Count	Frequency (%)
99403	24	< 0.1%
99402	25	< 0.1%
99401	24	< 0.1%
99371	27	< 0.1%
99363	24	< 0.1%
99362	21	< 0.1%
99361	27	< 0.1%
99360	29	< 0.1%
99359	19	< 0.1%
99357	29	< 0.1%

Title
Text

MISSING

Distinct	1325
Distinct (%)	0.2%
Missing	139876
Missing (%)	14.0%
Memory size	7.6 MiB

Length

Max length	48
Median length	33
Mean length	14.617727
Min length	3

Characters and Unicode

Total characters	12573058
Distinct characters	63
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Strange Magic
2nd row	Money Talks
3rd row	Big Ten Inch Record
4th row	The Ripper
5th row	Welcome To The Boomtown

Value	Count	Frequency (%)
the	141785	5.6%
in	67553	2.7%
you	60417	2.4%
on	48820	1.9%
of	45397	1.8%
to	44070	1.7%
a	43772	1.7%
love	34454	1.4%
me	33122	1.3%
rock	29876	1.2%
Other values (1391)	1999110	78.4%

Most occurring characters

Value	Count	Frequency (%)
	1699372	13.5%
e	1101890	8.8%
o	849324	6.8%
n	694516	5.5%
a	633815	5.0%
t	544215	4.3%
i	541449	4.3%
r	492237	3.9%
l	427958	3.4%
h	371978	3.0%
Other values (53)	5216304	41.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7883914	62.7%
Uppercase Letter	2934281	23.3%
Space Separator	1699372	13.5%
Decimal Number	55491	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1101890	14.0%
o	849324	10.8%
n	694516	8.8%
a	633815	8.0%
t	544215	6.9%
i	541449	6.9%
r	492237	6.2%
l	427958	5.4%
h	371978	4.7%
s	326211	4.1%
Other values (16)	1900321	24.1%

Uppercase Letter

Value	Count	Frequency (%)
T	275110	9.4%
S	209884	7.2%
L	196539	6.7%
A	175513	6.0%
I	173236	5.9%
O	172656	5.9%
R	170922	5.8%
M	160249	5.5%
B	159182	5.4%
H	157076	5.4%
Other values (16)	1083914	36.9%

Decimal Number

Value	Count	Frequency (%)
1	16716	30.1%
9	13363	24.1%
8	9105	16.4%
6	3871	7.0%
7	2897	5.2%
4	2809	5.1%
2	2228	4.0%
3	2104	3.8%
5	1511	2.7%
0	887	1.6%

Space Separator

Value	Count	Frequency (%)
	1699372	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10818195	86.0%
Common	1754863	14.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1101890	10.2%
o	849324	7.9%
n	694516	6.4%
a	633815	5.9%
t	544215	5.0%
i	541449	5.0%
r	492237	4.6%
l	427958	4.0%
h	371978	3.4%
s	326211	3.0%
Other values (42)	4834602	44.7%

Common

Value	Count	Frequency (%)
	1699372	96.8%
1	16716	1.0%
9	13363	0.8%
8	9105	0.5%
6	3871	0.2%
7	2897	0.2%
4	2809	0.2%
2	2228	0.1%
3	2104	0.1%
5	1511	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12573058	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1699372	13.5%
e	1101890	8.8%
o	849324	6.8%
n	694516	5.5%
a	633815	5.0%
t	544215	4.3%
i	541449	4.3%
r	492237	3.9%
l	427958	3.4%
h	371978	3.0%
Other values (53)	5216304	41.5%

Artist
Text

MISSING

Distinct	405
Distinct (%)	< 0.1%
Missing	139876
Missing (%)	14.0%
Memory size	7.6 MiB

Length

Max length	9136
Median length	44
Mean length	16.517932
Min length	3

Characters and Unicode

Total characters	14207470
Distinct characters	76
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Electric Light Orchestra
2nd row	AC/DC
3rd row	Aerosmith
4th row	Judas Priest
5th row	David & David

Value	Count	Frequency (%)
ac/dc	66532	3.2%
the	60727	3.0%
aerosmith	51197	2.5%
38	34002	1.7%
special	34002	1.7%
billy	29264	1.4%
band	27907	1.4%
bob	24915	1.2%
beatles	22382	1.1%
john	21856	1.1%
Other values (1598)	1684919	81.9%

Most occurring characters

Value	Count	Frequency (%)
e	1227129	8.6%
	1060483	7.5%
o	742453	5.2%
a	695485	4.9%
n	636405	4.5%
r	635431	4.5%
l	621649	4.4%
i	618513	4.4%
t	508210	3.6%
s	435640	3.1%
Other values (66)	7026072	49.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8398206	59.1%
Uppercase Letter	2989774	21.0%
Space Separator	1060483	7.5%
Decimal Number	1036070	7.3%
Other Punctuation	571432	4.0%
Control	141203	1.0%
Dash Punctuation	9586	0.1%
Open Punctuation	358	< 0.1%
Close Punctuation	358	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1227129	14.6%
o	742453	8.8%
a	695485	8.3%
n	636405	7.6%
r	635431	7.6%
l	621649	7.4%
i	618513	7.4%
t	508210	6.1%
s	435640	5.2%
h	327678	3.9%
Other values (17)	1949613	23.2%

Uppercase Letter

Value	Count	Frequency (%)
C	310726	10.4%
B	283874	9.5%
S	268342	9.0%
A	251567	8.4%
D	218936	7.3%
E	189434	6.3%
T	170610	5.7%
R	140799	4.7%
L	133184	4.5%
M	110416	3.7%
Other values (17)	911886	30.5%

Decimal Number

Value	Count	Frequency (%)
1	200538	19.4%
3	183318	17.7%
2	154890	14.9%
8	112363	10.8%
4	79964	7.7%
6	67980	6.6%
0	66326	6.4%
9	60744	5.9%
5	56019	5.4%
7	53928	5.2%

Other Punctuation

Value	Count	Frequency (%)
,	423609	74.1%
/	67778	11.9%
.	48902	8.6%
&	16505	2.9%
'	6782	1.2%
?	5004	0.9%
"	2852	0.5%

Space Separator

Value	Count	Frequency (%)
	1060483	100.0%

Control

Value	Count	Frequency (%)
	141203	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	9586	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	358	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	358	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11387980	80.2%
Common	2819490	19.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1227129	10.8%
o	742453	6.5%
a	695485	6.1%
n	636405	5.6%
r	635431	5.6%
l	621649	5.5%
i	618513	5.4%
t	508210	4.5%
s	435640	3.8%
h	327678	2.9%
Other values (44)	4939387	43.4%

Common

Value	Count	Frequency (%)
	1060483	37.6%
,	423609	15.0%
1	200538	7.1%
3	183318	6.5%
2	154890	5.5%
	141203	5.0%
8	112363	4.0%
4	79964	2.8%
6	67980	2.4%
/	67778	2.4%
Other values (12)	327364	11.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14205210	> 99.9%
None	2260	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1227129	8.6%
	1060483	7.5%
o	742453	5.2%
a	695485	4.9%
n	636405	4.5%
r	635431	4.5%
l	621649	4.4%
i	618513	4.4%
t	508210	3.6%
s	435640	3.1%
Other values (64)	7023812	49.4%

None

Value	Count	Frequency (%)
Ö	1867	82.6%
ÿ	393	17.4%

Length
Real number (ℝ)

MISSING

Distinct	240
Distinct (%)	< 0.1%
Missing	139876
Missing (%)	14.0%
Infinite	0
Infinite (%)	0.0%
Mean	237.13538

Minimum	120
Maximum	359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	120
5-th percentile	131
Q1	180
median	232
Q3	299
95-th percentile	345
Maximum	359
Range	239
Interquartile range (IQR)	119

Descriptive statistics

Standard deviation	68.858821
Coefficient of variation (CV)	0.29037768
Kurtosis	-1.2023644
Mean	237.13538
Median Absolute Deviation (MAD)	60
Skewness	0.060875619
Sum	2.0396583 × 10⁸
Variance	4741.5373
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	13102	1.3%
269	11763	1.2%
219	10241	1.0%
143	9645	1.0%
221	9472	0.9%
341	9403	0.9%
334	8738	0.9%
154	8535	0.9%
163	8463	0.8%
135	7966	0.8%
Other values (230)	762796	76.3%
(Missing)	139876	14.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
120	2437	0.2%
121	1053	0.1%
122	3979	0.4%
123	5150	0.5%
124	3190	0.3%
125	1318	0.1%
126	1751	0.2%
127	6974	0.7%
128	5942	0.6%
129	3092	0.3%

Value	Count	Frequency (%)
359	1831	0.2%
358	2643	0.3%
357	2877	0.3%
356	4246	0.4%
355	5130	0.5%
354	1609	0.2%
353	2289	0.2%
352	3788	0.4%
351	2619	0.3%
350	3369	0.3%

Name
Text

Distinct	4946
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

Length

Max length	21
Median length	19
Mean length	13.064705
Min length	7

Characters and Unicode

Total characters	13064705
Distinct characters	52
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Lucas Pizano
2nd row	Kenneth Rodgers
3rd row	Carlos Kirk
4th row	Charlene Boyd
5th row	Mary Decker

Value	Count	Frequency (%)
james	23853	1.2%
robert	19330	1.0%
david	17934	0.9%
john	16101	0.8%
mary	14755	0.7%
william	14321	0.7%
smith	12018	0.6%
brown	11792	0.6%
richard	11775	0.6%
michael	11721	0.6%
Other values (3920)	1846400	92.3%

Most occurring characters

Value	Count	Frequency (%)
e	1265195	9.7%
a	1193996	9.1%
r	1003801	7.7%
	1000000	7.7%
n	934548	7.2%
i	775493	5.9%
o	756781	5.8%
l	707165	5.4%
s	498850	3.8%
t	483811	3.7%
Other values (42)	4445065	34.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10064705	77.0%
Uppercase Letter	2000000	15.3%
Space Separator	1000000	7.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1265195	12.6%
a	1193996	11.9%
r	1003801	10.0%
n	934548	9.3%
i	775493	7.7%
o	756781	7.5%
l	707165	7.0%
s	498850	5.0%
t	483811	4.8%
h	361616	3.6%
Other values (16)	2083449	20.7%

Uppercase Letter

Value	Count	Frequency (%)
M	189453	9.5%
J	173452	8.7%
S	152426	7.6%
C	144375	7.2%
B	132754	6.6%
R	132114	6.6%
D	116408	5.8%
G	98285	4.9%
A	97050	4.9%
W	96708	4.8%
Other values (15)	666975	33.3%

Space Separator

Value	Count	Frequency (%)
	1000000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12064705	92.3%
Common	1000000	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1265195	10.5%
a	1193996	9.9%
r	1003801	8.3%
n	934548	7.7%
i	775493	6.4%
o	756781	6.3%
l	707165	5.9%
s	498850	4.1%
t	483811	4.0%
h	361616	3.0%
Other values (41)	4083449	33.8%

Common

Value	Count	Frequency (%)
	1000000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13064705	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1265195	9.7%
a	1193996	9.1%
r	1003801	7.7%
	1000000	7.7%
n	934548	7.2%
i	775493	5.9%
o	756781	5.8%
l	707165	5.4%
s	498850	3.8%
t	483811	3.7%
Other values (42)	4445065	34.0%

Gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

0	605868
1	394132

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1000000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	605868	60.6%
1	394132	39.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	605868	60.6%
1	394132	39.4%

Most occurring characters

Value	Count	Frequency (%)
0	605868	60.6%
1	394132	39.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1000000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	605868	60.6%
1	394132	39.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	1000000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	605868	60.6%
1	394132	39.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1000000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	605868	60.6%
1	394132	39.4%

Address
Text

Distinct	5000
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

Length

Max length	34
Median length	32
Mean length	23.045462
Min length	16

Characters and Unicode

Total characters	23045462
Distinct characters	60
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2723 Stony Beaver Hollow
2nd row	74413 Heather Elm Bluff
3rd row	14 Hidden Bear Circle
4th row	5967 Stony Branch Stroll
5th row	16355 Pretty Panda Pike

Value	Count	Frequency (%)
bluff	24115	0.6%
gate	23299	0.6%
villa	22007	0.6%
round	20539	0.5%
dale	20333	0.5%
easy	20127	0.5%
view	19409	0.5%
hickory	18762	0.5%
grove	18738	0.5%
vale	18412	0.5%
Other values (4965)	3794259	94.9%

Most occurring characters

Value	Count	Frequency (%)
	3000000	13.0%
e	1754870	7.6%
a	1187818	5.2%
r	1099797	4.8%
n	1029253	4.5%
o	1007033	4.4%
l	937214	4.1%
t	760803	3.3%
i	725636	3.1%
1	554502	2.4%
Other values (50)	10988536	47.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12491665	54.2%
Decimal Number	4553797	19.8%
Space Separator	3000000	13.0%
Uppercase Letter	3000000	13.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1754870	14.0%
a	1187818	9.5%
r	1099797	8.8%
n	1029253	8.2%
o	1007033	8.1%
l	937214	7.5%
t	760803	6.1%
i	725636	5.8%
d	551244	4.4%
u	515578	4.1%
Other values (15)	2922419	23.4%

Uppercase Letter

Value	Count	Frequency (%)
B	307561	10.3%
C	289044	9.6%
S	286087	9.5%
P	233871	7.8%
R	218032	7.3%
H	194661	6.5%
L	178448	5.9%
T	171053	5.7%
G	151571	5.1%
A	132629	4.4%
Other values (14)	837043	27.9%

Decimal Number

Value	Count	Frequency (%)
1	554502	12.2%
2	489314	10.7%
4	488163	10.7%
5	468402	10.3%
3	462599	10.2%
7	434752	9.5%
6	428963	9.4%
8	426936	9.4%
9	416565	9.1%
0	383601	8.4%

Space Separator

Value	Count	Frequency (%)
	3000000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15491665	67.2%
Common	7553797	32.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1754870	11.3%
a	1187818	7.7%
r	1099797	7.1%
n	1029253	6.6%
o	1007033	6.5%
l	937214	6.0%
t	760803	4.9%
i	725636	4.7%
d	551244	3.6%
u	515578	3.3%
Other values (39)	5922419	38.2%

Common

Value	Count	Frequency (%)
	3000000	39.7%
1	554502	7.3%
2	489314	6.5%
4	488163	6.5%
5	468402	6.2%
3	462599	6.1%
7	434752	5.8%
6	428963	5.7%
8	426936	5.7%
9	416565	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	23045462	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3000000	13.0%
e	1754870	7.6%
a	1187818	5.2%
r	1099797	4.8%
n	1029253	4.5%
o	1007033	4.4%
l	937214	4.1%
t	760803	3.3%
i	725636	3.1%
1	554502	2.4%
Other values (50)	10988536	47.7%

zip
Real number (ℝ)

Distinct	4695
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50410.68

Minimum	1002
Maximum	99347
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	1002
5-th percentile	6858
Q1	27358
median	50207
Q3	73156
95-th percentile	95229
Maximum	99347
Range	98345
Interquartile range (IQR)	45798

Descriptive statistics

Standard deviation	27648.099
Coefficient of variation (CV)	0.54845718
Kurtosis	-1.1382585
Mean	50410.68
Median Absolute Deviation (MAD)	22925
Skewness	0.030620293
Sum	5.041068 × 10¹⁰
Variance	7.6441739 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
72132	7213	0.7%
17307	5075	0.5%
66216	4064	0.4%
36690	3438	0.3%
61377	3261	0.3%
20115	2960	0.3%
15330	2655	0.3%
33570	2498	0.2%
41240	2311	0.2%
63565	2276	0.2%
Other values (4685)	964249	96.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1002	437	< 0.1%
1037	92	< 0.1%
1066	157	< 0.1%
1082	162	< 0.1%
1092	168	< 0.1%
1115	110	< 0.1%
1195	107	< 0.1%
1235	195	< 0.1%
1253	832	0.1%
1256	226	< 0.1%

Value	Count	Frequency (%)
99347	129	< 0.1%
99346	178	< 0.1%
99330	99	< 0.1%
99256	1027	0.1%
99223	111	< 0.1%
99206	98	< 0.1%
99176	141	< 0.1%
99173	117	< 0.1%
99158	289	< 0.1%
99153	434	< 0.1%

SignDate
Date

Distinct	455
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

Minimum	2011-05-10 00:00:00
Maximum	2013-07-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Status
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

1	900436
0	99564

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1000000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	900436	90.0%
0	99564	10.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	900436	90.0%
0	99564	10.0%

Most occurring characters

Value	Count	Frequency (%)
1	900436	90.0%
0	99564	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1000000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	900436	90.0%
0	99564	10.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1000000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	900436	90.0%
0	99564	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1000000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	900436	90.0%
0	99564	10.0%

Level
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

0	565316
1	332656
2	102028

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1000000
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	2
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	565316	56.5%
1	332656	33.3%
2	102028	10.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	565316	56.5%
1	332656	33.3%
2	102028	10.2%

Most occurring characters

Value	Count	Frequency (%)
0	565316	56.5%
1	332656	33.3%
2	102028	10.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1000000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	565316	56.5%
1	332656	33.3%
2	102028	10.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	1000000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	565316	56.5%
1	332656	33.3%
2	102028	10.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1000000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	565316	56.5%
1	332656	33.3%
2	102028	10.2%

Campaign
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

1	596844
4	142050
0	118043
3	95621
2	47442

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1000000
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	1
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
1	596844	59.7%
4	142050	14.2%
0	118043	11.8%
3	95621	9.6%
2	47442	4.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	596844	59.7%
4	142050	14.2%
0	118043	11.8%
3	95621	9.6%
2	47442	4.7%

Most occurring characters

Value	Count	Frequency (%)
1	596844	59.7%
4	142050	14.2%
0	118043	11.8%
3	95621	9.6%
2	47442	4.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1000000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	596844	59.7%
4	142050	14.2%
0	118043	11.8%
3	95621	9.6%
2	47442	4.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	1000000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	596844	59.7%
4	142050	14.2%
0	118043	11.8%
3	95621	9.6%
2	47442	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1000000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	596844	59.7%
4	142050	14.2%
0	118043	11.8%
3	95621	9.6%
2	47442	4.7%

LinkedWithApps
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

1	504687
0	495313

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1000000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
1	504687	50.5%
0	495313	49.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	504687	50.5%
0	495313	49.5%

Most occurring characters

Value	Count	Frequency (%)
1	504687	50.5%
0	495313	49.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1000000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	504687	50.5%
0	495313	49.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	1000000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	504687	50.5%
0	495313	49.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1000000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	504687	50.5%
0	495313	49.5%

Auto

Heatmap
Table

	Campaign	CustID	EventID	Gender	Length	Level	LinkedWithApps	Mobile	Status	TrackId	ZipCode	zip
Campaign	1.000	0.026	0.001	0.029	-0.001	0.054	0.043	0.015	0.031	0.001	0.001	-0.018
CustID	0.026	1.000	0.000	0.046	-0.000	0.039	0.038	0.010	0.037	-0.000	0.001	-0.018
EventID	0.001	0.000	1.000	0.000	0.003	0.000	0.001	0.002	0.002	0.001	-0.001	-0.001
Gender	0.029	0.046	0.000	1.000	-0.002	0.008	0.007	0.001	0.008	-0.001	-0.000	-0.021
Length	-0.001	-0.000	0.003	-0.002	1.000	0.000	0.002	0.000	0.001	0.052	0.000	-0.000
Level	0.054	0.039	0.000	0.008	0.000	1.000	0.053	0.259	0.046	-0.001	0.002	0.004
LinkedWithApps	0.043	0.038	0.001	0.007	0.002	0.053	1.000	0.014	0.019	0.001	0.001	-0.003
Mobile	0.015	0.010	0.002	0.001	0.000	0.259	0.014	1.000	0.011	-0.001	0.000	0.000
Status	0.031	0.037	0.002	0.008	0.001	0.046	0.019	0.011	1.000	-0.000	-0.000	-0.006
TrackId	0.001	-0.000	0.001	-0.001	0.052	-0.001	0.001	-0.001	-0.000	1.000	-0.001	-0.001
ZipCode	0.001	0.001	-0.001	-0.000	0.000	0.002	0.001	0.000	-0.000	-0.001	1.000	0.000
zip	-0.018	-0.018	-0.001	-0.021	-0.000	0.004	-0.003	0.000	-0.006	-0.001	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	EventID	CustID	TrackId	DateTime	Mobile	ZipCode	Title	Artist	Length	Name	Gender	Address	zip	SignDate	Status	Level	Campaign	LinkedWithApps
0	0	48	453	10/23/14 3:26	0	72132	Strange Magic	Electric Light Orchestra	170.0	Lucas Pizano	0	2723 Stony Beaver Hollow	99256	11/02/2012	1	0	3	1
1	1	1081	19	10/15/14 18:32	1	17307	Money Talks	AC/DC	323.0	Kenneth Rodgers	0	74413 Heather Elm Bluff	30301	05/14/2013	0	1	1	1
2	2	532	36	12/10/14 15:33	1	66216	Big Ten Inch Record	Aerosmith	204.0	Carlos Kirk	0	14 Hidden Bear Circle	90745	07/14/2013	0	2	1	1
3	3	2641	822	10/20/14 2:24	1	36690	The Ripper	Judas Priest	122.0	Charlene Boyd	0	5967 Stony Branch Stroll	4645	03/26/2013	1	1	1	0
4	4	2251	338	11/18/14 7:16	1	61377	Welcome To The Boomtown	David & David	269.0	Mary Decker	0	16355 Pretty Panda Pike	40580	06/23/2013	1	1	0	1
5	5	1811	6	11/18/14 2:00	1	20115	Loser	3 Doors Down	127.0	Joshua Reyna	0	987 Cotton Maple Turn	24574	01/14/2013	1	1	1	1
6	6	3644	24	12/12/14 15:24	1	15330	Shot Down In Flames	AC/DC	326.0	Cynthia Moses	1	86610 Misty Nectar Drive	23857	06/25/2013	1	0	1	0
7	7	250	726	10/7/14 9:48	0	33570	Right Here Right Now	Jesus Jones	232.0	Nell Rosenblum	1	18820 Birch Mill Twist	72443	12/05/2012	1	0	1	1
8	8	1782	442	12/30/14 15:27	1	41240	Baby Hold On	Eddie Money	298.0	Jason Witzel	0	76 Jagged Barn Turn	28086	07/19/2013	1	2	3	1
9	9	2932	775	11/12/14 7:45	0	63565	On the Dark Side	John Cafferty	213.0	Darlene Rahn	0	4 Tawny Beaver Ledge	7737	05/11/2013	1	0	1	0

	EventID	CustID	TrackId	DateTime	Mobile	ZipCode	Title	Artist	Length	Name	Gender	Address	zip	SignDate	Status	Level	Campaign	LinkedWithApps
999990	999990	209	1235	10/21/14 2:38	0	14723	NaN	NaN	NaN	Billy Gifford	0	4 White Hickory Falls	54413	12/08/2012	0	0	4	1
999991	999991	236	510	11/2/14 0:03	1	1266	All The Kings Horses	Firm	301.0	Johnny Moore	1	36198 Cozy Turtle Glen	65212	06/22/2013	1	0	1	0
999992	999992	1017	835	12/8/14 7:06	1	6020	NaN	NaN	NaN	Joshua Waldron	0	26401 Heather Castle Circle	20195	06/27/2013	1	0	1	0
999993	999993	3884	303	10/22/14 12:34	1	45264	White Room	Cream	344.0	Terry Mulligan	0	89241 White Prairie Wander	87319	07/31/2013	0	0	1	1
999994	999994	136	49	10/20/14 19:37	1	27822	No More No More	Aerosmith	145.0	Dona Casey	1	51613 Burning Anchor Haven	31520	10/02/2012	1	2	1	1
999995	999995	3363	144	10/23/14 3:58	1	50302	The Stranger	Billy Joel	122.0	Bobbie Wingfield	1	49345 Rough Sky Stead	20724	07/21/2013	1	2	1	0
999996	999996	210	507	11/18/14 0:20	1	75550	Stay With Me	Faces	324.0	Francis Ryan	1	61901 Amber Island Falls	15520	07/11/2013	1	0	1	0
999997	999997	751	1397	11/3/14 9:36	1	29912	NaN	NaN	NaN	Carrie King	1	22811 Sleepy Elk Mews	74577	01/11/2013	1	0	1	0
999998	999998	4717	1328	10/26/14 4:04	1	58425	NaN	NaN	NaN	Rachel Dvorak	0	78831 Round Shadow Lane	31068	03/19/2013	1	0	3	1
999999	999999	3014	374	12/10/14 19:46	1	29856	Armageddon It	Def Leppard	173.0	Craig Mcpherson	0	35949 Dusty Dove Heights	50501	05/04/2013	1	2	4	1

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Control

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter